Sometimes, because of project development, some tables in the SQLServer2005 must be synchronized to the Oracle database, which can be read by other systems. Data synchronization between different database types can be implemented using linked
Oracle basic concepts and comparison with informix
I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user
In Oracle, fields of the lob (large object, large object) type are increasingly used. This type of field has a large capacity (up to 4 GB of data), and a table can have multiple fields of this type, which is flexible, applicable to business areas
When the database needs to recover the media, in order to ensure that the database can smoothly perform the recovery process, restore the database to the current state. All we need to do is verify! What is verification? Of course, it is to verify
Oracle EBS is relatively large and has many modules. The abbreviations and full names of some modules are listed here.
ABM-Activity Based ManagementAD-Applications DBAAHL-Oracle Advanced Service OnlineAK-Oracle Common Modules-AKALR-Oracle
In Oracle, fields of the lob (large object, large object) type are increasingly used. This type of field has a large capacity (up to 4 GB of data), and a table can have multiple fields of this type, which is flexible, applicable to business areas
1,OracleOfficial preparations recommended by the company
Generally speaking, Oracle has a lot of examination content, and the examination questions are also very detailed, it has a strong requirement on hands-on ability. Therefore, in order to be
Created:
Article attributes: original
Article submission: T_Torchidy (jnchaha_at_163.com)
Oracle web Environment Injection Technology## BY Jianxin# Http://www.loveshell.net/#
Preface
I am not a professional database administrator, nor a researcher
Manpower.s_salary 375w record, add field add_sh number (7,2) default 0
1. Excluding the use of the first
SELECT P.spid,s.status,s.terminal,s.machine,s.program,s.osuser,s.client_info,s.logon_time from V$SESSION S,V$ ACCESS a,v$process PWHERE S.sid=a.
1. Oracle startup and Shutdown1. In a single-host environmentTo start or shut down the Oracle system, you must first switch to the Oracle user, as shown below:Su-Oracle
A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.